<%--
  Created by IntelliJ IDEA.
  User: 吧
  Date: 2020/11/271l
  Time: 17:15
  To change this template use File | Settings | File Templates.
--%>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>新闻阅览</title>

    <%--引入css文件和js文件--%>
    <link rel="stylesheet" href="css/bootstrap.css">

    <script src="js/jquery.min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/bootstrap.bundle.js"></script>

    <style>
        .container{
            margin-top: 5%;
        }
    </style>

</head>
<body>
<%
    if(session.getAttribute("username") == null){
        //表示尚未登录
        out.print("你尚未登录，3秒之后跳转登录页面");
        response.setHeader("refresh","3;url=login.jsp");
    }else{
        //加载数据库驱动
        Class.forName("com.mysql.jdbc.Driver");

        //建立数据库连接
        String url = "jdbc:mysql://localhost:3306/book1"; //数据库连接地址
        Connection connection = DriverManager.getConnection(url,"root","root"); //第一个root为数据库的用户名  第二个root为数据库的密码

        String sql = "select * from user"; //在PreparedStatement 中使用问好代替实际参数
        PreparedStatement ps = connection.prepareStatement(sql);

        ResultSet rs = ps.executeQuery();

%>

<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <h3 style="text-align:center">欢迎来到个人主页!</h3>
            <a id="modal-addUser" href="#modal-container-addUser" role="button" class="btn" data-toggle="modal">添加用户</a>

            <a href="login?invalid=1" class="btn" >Logout</a>

            <table class="table table-striped">
                <thead>
                <th>ID</th>
                <th>用户名</th>
                <th>性别</th>
                <th>年龄</th>
                <th>操作</th>
                </thead>
                <tbody>
                <%
                        while (rs.next()){
                            out.print("<tr>");
                            out.print(
                                    "<td>"+rs.getString("id")
                                            +"</td><td>"+rs.getString("username")
                                            +"</td><td>"+rs.getString("gender")
                                            +"</td><td>"+rs.getString("age")
                                            +"</td>"
                                            +"<td><a href='delete.jsp?id="+rs.getString("id")+"'>delete</a>"
                                            + "&nbsp &nbsp;<a href='edit.jsp?id="+rs.getString("id")+"'>modify</a>"+
                                            "</td>"
                            );
                            out.print("</tr>");
                        }
                    }
                %>
                </tbody>
            </table>
        </div>
    </div>
</div>

<div class="modal fade" id="modal-container-addUser" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h4 class="modal-title" id="myModalLabel">
                    Add User
                </h4>
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
            </div>
            <form method="post" action="add.jsp">
                <div class="modal-body">
                    <div class="form-group">
                        <label>用户名:</label><input type="text" name="username" class="form-control"  />
                    </div>
                    <div class="form-group">
                        <label>密码:</label><input type="password" name="password" class="form-control" />
                    </div>
                    <div class="form-group">
                        <label>性别:</label><input type="text" name="gender" class="form-control"/>
                    </div>
                    <div class="form-group">
                        <label>年龄:</label><input type="text" name="age" class="form-control"/>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
                    <button type="submit" class="btn btn-primary">提交</button>
                </div>
            </form>
        </div>
    </div>
</div>


</body>
</html>
